REM  SQL scripts from Chapter 1 of ORACLE8 DBA Handbook by Kevin Loney.
REM  See www.osborne.com for updates to these scripts.


create table EMPLOYEE
(EmpNo            NUMBER(10)    PRIMARY KEY,
 Name             VARCHAR2(40)  NOT NULL,
 DeptNo           NUMBER(2)     DEFAULT 10,
 Salary           NUMBER(7,2)   CHECK salary<1000000,
 Birth_Date       DATE,
 Soc_Sec_Num      CHAR(9)       UNIQUE,
 foreign key (DeptNo) references DEPT.DeptNo)
tablespace USERS;


create type NAME_TY as object
(First_Name     VARCHAR2(25),
Middle_Initial  CHAR(1),
Last_Name       VARCHAR2(30),
Suffix          VARCHAR2(5));


create table EMPLOYEE
(EmpNo            NUMBER(10)    PRIMARY KEY,
 Name             NAME_TY,
 DeptNo           NUMBER(2)     DEFAULT 10,
 Salary           NUMBER(7,2)   CHECK salary<1000000,
 Birth_Date       DATE,
 Soc_Sec_Num      CHAR(9)       UNIQUE,
 foreign key (DeptNo) references DEPT.DeptNo)
tablespace USERS;


create table NAME of NAME_TY;


create public database link MY_LINK
connect to HR identified by PUFFINSTUFF
using 'DB1';



